fikgt
Tables (12)
CAST_TB
- cast_pk — int — Primary key — NOT NULL
- Field — VARCHAR(255)
CATEGOTY_TB
- category_pk — int — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
OPTION_TB
- option_pk — int — Primary key — NOT NULL
- show_pk — int — Foreign key → SHOW_TB.show_pk — NOT NULL
- seller_pk — int — Foreign key → SHOW_TB.seller_pk — NOT NULL
- user_pk — int — Foreign key → SHOW_TB.user_pk — NOT NULL
- category_pk — int — Foreign key → SHOW_TB.category_pk — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
REVIEW_TB
- review_pk — int — Primary key — NOT NULL
- user_pk2 — int — Foreign key → USER_TB.user_pk — NOT NULL
- show_pk — int — Foreign key → SHOW_TB.show_pk — NOT NULL
- seller_pk — int — Foreign key → SHOW_TB.seller_pk — NOT NULL
- user_pk — int — Foreign key → SHOW_TB.user_pk — NOT NULL
- category_pk — int — Foreign key → SHOW_TB.category_pk — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
SEAT_TB
- seat_pk — int — Primary key — NOT NULL
- option_pk — int — Foreign key → OPTION_TB.option_pk — NOT NULL
- show_pk — int — Foreign key → OPTION_TB.show_pk — NOT NULL
- seller_pk — int — Foreign key → OPTION_TB.seller_pk — NOT NULL
- user_pk — int — Foreign key → OPTION_TB.user_pk — NOT NULL
- category_pk — int — Foreign key → OPTION_TB.category_pk — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
SELLER_TB
- seller_pk — int — Primary key — NOT NULL
- user_pk — int — Foreign key → USER_TB.user_pk — NOT NULL
- Field — VARCHAR(255)
SHOW_DETAIL_TB
- show_detail_pk — int — Primary key — NOT NULL
- show_pk — int — Foreign key → SHOW_TB.show_pk — NOT NULL
- seller_pk — int — Foreign key → SHOW_TB.seller_pk — NOT NULL
- user_pk — int — Foreign key → SHOW_TB.user_pk — NOT NULL
- category_pk — int — Foreign key → SHOW_TB.category_pk — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
SHOW_TB
- show_pk — int — Primary key — NOT NULL
- seller_pk — int — Foreign key → SELLER_TB.seller_pk — NOT NULL
- user_pk — int — Foreign key → SELLER_TB.user_pk — NOT NULL
- category_pk — int — Foreign key → CATEGOTY_TB.category_pk — NOT NULL
- cast_pk — int — NOT NULL
- Field — VARCHAR(255)
- Field11 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field10 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field13 — VARCHAR(255)
- Field15 — VARCHAR(255)
- Field14 — VARCHAR(255)
- Field16 — VARCHAR(255)
- Field2 — decimal(16,14)
- Field3 — decimal(17,14)
TICKETING_TB
- order_pk — int — Primary key — NOT NULL
- user_pk2 — int — Foreign key → USER_TB.user_pk — NOT NULL
- show_pk — int — Foreign key → SHOW_TB.show_pk — NOT NULL
- seller_pk — int — Foreign key → SHOW_TB.seller_pk — NOT NULL
- user_pk — int — Foreign key → SHOW_TB.user_pk — NOT NULL
- category_pk — int — Foreign key → SHOW_TB.category_pk — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
USER_TB
- user_pk — int — Primary key — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- user_pw — VARCHAR2(255) — NOT NULL
- Field13 — VARCHAR(255) — NOT NULL
- Field123 — VARCHAR(255) — NOT NULL
- - — VARCHAR(255) — NOT NULL
- Field5 — VARCHAR(255) — NOT NULL
- Field4 — VARCHAR(255) — NOT NULL
- Field7 — VARCHAR(255)
- Field12 — VARCHAR(255) — NOT NULL
- Field3 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field10 — VARCHAR(255)
- Field11 — VARCHAR(255)
- Field2 — VARCHAR(255)
Untitled
- Key — VARCHAR(255) — Primary key — NOT NULL
- show_pk — int — NOT NULL
- seller_pk — int — NOT NULL
- user_pk — int — NOT NULL
- Field — VARCHAR(255)
- category_pk — int — NOT NULL
WISHLIST_TB
- wishlist_pk — int — Primary key — NOT NULL
- user_pk2 — int — Foreign key → USER_TB.user_pk — NOT NULL
- show_pk — int — Foreign key → SHOW_TB.show_pk — NOT NULL
- seller_pk — int — Foreign key → SHOW_TB.seller_pk — NOT NULL
- user_pk — int — Foreign key → SHOW_TB.user_pk — NOT NULL
- category_pk — int — Foreign key → SHOW_TB.category_pk — NOT NULL
- Field — VARCHAR(255)