Created
December 23, 2021 23:59
-
-
Save 1ambda/44b760191681862da550428d2266f5dd to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE pipeline; | |
USE pipeline; | |
-- 아래의 테이블은 이해를 돕기 위해 약식으로 생성되었습니다. | |
-- Production 환경에서 테이블 생성시에는 성능과 스펙을 고려해 DDL 이 작성되며 DBA 의 검수를 거칩니다. | |
CREATE TABLE `ListingMeta` | |
( | |
-- primary key | |
`listing_id` BIGINT UNSIGNED NOT NULL PRIMARY KEY, | |
`listing_name` VARCHAR(200) NULL, | |
`listing_desc` TEXT NULL, | |
`listing_summary` TEXT NULL, | |
`listing_url` TEXT NULL, | |
-- FK columns | |
-- common | |
`created_at` datetime DEFAULT CURRENT_TIMESTAMP NOT NULL | |
) ENGINE = InnoDB | |
DEFAULT CHARSET = utf8mb4 | |
COLLATE = utf8mb4_unicode_ci; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment