SeoulTour
Tables (10)
Calendar (Untitled8)
- calendar_id (PK) — int — Primary key — NOT NULL
- fav_place_id (PK2) — int — Foreign key → FavPlace.fav_place_id — NOT NULL
- map_id (PK22) — int — Foreign key → FavPlace.map_id — NOT NULL
- user_id (PK222) — int — Foreign key → FavPlace.user_id — NOT NULL
- fav_place_id (Field2) — int
- user_id (Field) — int
- tour_start_date (Field3) — varchar
- tour_end_date (Field4) — varchar
- place_name (Field5) — varchar
- schedule_time (Field6) — varchar
- schedule_date (Field7) — varchar
- memo (Field8) — TEXT
- Field9
CalendarDetails (CopyOfUntitled7)
- calendar_details_id (PK) — int — Primary key — NOT NULL
- calendar_id (PK2) — int — Foreign key → Calendar.calendar_id — NOT NULL
- fav_place_id (PK22) — int — Foreign key → Calendar.fav_place_id — NOT NULL
- map_id (PK222) — int — Foreign key → Calendar.map_id — NOT NULL
- user_id (PK2222) — int — Foreign key → Calendar.user_id — NOT NULL
- calendar_id (Field14) — int
- place_name (Field) — varchar
- place_image (Field6) — varchar(255)
- operation_time (Field2) — varchar
- operation_date (Field3) — varchar
- day_off (Field4) — varchar
- place_location (Field5) — varchar
- place_contact_num (Field7) — varchar
- place_details_info (Field10) — TEXT
- schedule_time (Field8) — varchar
- schedule_date (Field9) — varchar
- memo (Field15) — TEXT
- Field11
DeliveryInfo (Untitled9)
- delivery_info_id (PK) — int — Primary key — NOT NULL
- user_id (PK2) — int — Foreign key → User.user_id — NOT NULL
- user_id (Field) — int
- receiver_name (Field2) — varchar
- receiver_phone (Field3) — CHAR(11)
- main_address (Field4) — varchar
- details_address (Field5) — varchar
- zip_code (Field7) — varchar
- expected_delivery (Field6) — TIMESTAMP
FavPlace (Untitled7)
- fav_place_id (PK) — int — Primary key — NOT NULL
- map_id (PK2) — int — Foreign key → Map.map_id — NOT NULL
- user_id (PK22) — int — Foreign key → Map.user_id — NOT NULL
- user_id (Field12) — int
- place_name (Field) — varchar
- place_image (Field6) — varchar(255)
- place_location (Field5) — varchar
- place_details_info (Field10) — TEXT
- like_status (Field11) — boolean
Map (Untitled2)
- map_id (PK) — int — Primary key — NOT NULL
- user_id (PK2) — int — Foreign key → User.user_id — NOT NULL
- user_id (Field4) — int
- latitude (Field) — varchar
- longtitude (Field2) — varchar
- place_name (Field3) — varchar
- place_image (Field5) — varchar(255)
- place_info (Field6) — TEXT
- place_details_info (Field11) — TEXT
- operation_time (Field7) — varchar
- operation_date (Field8) — varchar
- place_location (Field9) — varchar
- place_contact_num (Field10) — varchar
Order (Untitled4)
- order_id (Key) — int — Primary key — NOT NULL
- goods_id (PK) — int — Foreign key → TraditionalGoods.goods_id — NOT NULL
- user_id (PK2) — int — Foreign key → TraditionalGoods.user_id — NOT NULL
- payment_id (Field) — int
- goods_id (Field2) — int
- quantity (Field3) — int
- total_price (Field4) — int
- order_status (Field5) — varchar
Payment (Untitled3)
- payment_id (PK) — int — Primary key — NOT NULL
- order_id (Key) — int — Foreign key → Order.order_id — NOT NULL
- goods_id (PK2) — int — Foreign key → Order.goods_id — NOT NULL
- user_id (PK22) — int — Foreign key → Order.user_id — NOT NULL
- user_id (PK3) — int — Foreign key → User.user_id — NOT NULL
- user_id (Field) — int
- imp_uid (Field3) — varchar
- merchant_uid (Field4) — varchar
- payment_card (Field6) — CHAR(16)
- total_price (Field2) — int
- payment_date (Field5) — TIMESTAMP
- payment_status (Field7) — varchar
Statistic (Untitled6)
- statistic_id (PK) — int — Primary key — NOT NULL
- Field
- Field2
TraditionalGoods (Untitled5)
- goods_id (PK) — int — Primary key — NOT NULL
- user_id (PK2) — int — Foreign key → User.user_id — NOT NULL
- goods_name (Field) — varchar
- goods_image (Field4) — varchar(255)
- price (Field2) — int
- stock_quantity (Field3) — int
- sale_start_time (Field5) — TIMESTAMP
- sale_end_time (Field10) — TIMESTAMP
- goods_size (Field6) — varchar
- goods_weight (Field7) — varchar
- summary (Field8) — TEXT
- category (Field9) — varchar
User (Untitled)
- user_id (PK) — int — Primary key — NOT NULL
- email (Field) — varchar
- password (Field2) — CHAR(72)
- user_name (Field3) — varchar
- created_at (Field4) — TIMESTAMP
- deleted_at (Field5) — TIMESTAMP