Fandom K_YJK
Tables (13)
Costomer (Customer)
- CUST_ID — VARCHAR(50) — Primary key — NOT NULL
- EMAIL — VARCHAR(50)
- PW — INT — NOT NULL
- NAME — VARCHAR(50) — NOT NULL
Deposit
- DNUM — INT — Primary key — NOT NULL
- CUST_ID — VARCHAR(50) — Foreign key → Costomer.CUST_ID — NOT NULL
- D_CREDIT — INT — NOT NULL
- D_AMOUNT — INT — NOT NULL
Employee
- Employee_ID — VARCHAR(50) — Primary key — NOT NULL
- E_NAME — VARCHAR(50) — NOT NULL
- E_CON — INT
- EP_MAIL — VARCHAR(50)
Event
- EVENT_ID — VARCHAR(50) — Primary key — NOT NULL
- TARGET_AMOUNT — INT — NOT NULL
- TARGET_CREDIT — INT — NOT NULL
Follow
- FNUM — INT — Primary key — NOT NULL
- CUST_ID — VARCHAR(50) — Foreign key → Costomer.CUST_ID — NOT NULL
- IDOL_ID — VARCHAR(50) — Foreign key → Idol.IDOL_ID — NOT NULL
- FTIME — TIME — NOT NULL
- FDATE — DATE — NOT NULL
Group
- GROUP_ID — VARCHAR(50) — Primary key — NOT NULL
- IDOL_ID — VARCHAR(50) — Foreign key → Idol.IDOL_ID — NOT NULL
- I_COUNT — INT — NOT NULL
Idol
- IDOL_ID — VARCHAR(50) — Primary key — NOT NULL
- I_CO_ID — VARCHAR(50)
- M_F — VARCHAR(50) — NOT NULL
Interested_idol
- IDOL_ID — VARCHAR(50) — Foreign key → Idol.IDOL_ID — NOT NULL
- CUST_ID — VARCHAR(50) — Foreign key → Costomer.CUST_ID — NOT NULL
Post
- P_ID — VARCHAR(50) — Primary key — NOT NULL
- IDOL_ID — VARCHAR(50) — Foreign key → Idol.IDOL_ID — NOT NULL
- Employee_ID — VARCHAR(50) — Foreign key → Employee.Employee_ID — NOT NULL
- P_TITLE — VARCHAR(50)
- U_TIME — TIME — NOT NULL
- U_DATE — DATE — NOT NULL
- D_TIME — TIME
- D_DATE (D_DATE') — DATE
- R_TIME — TIME
- R_DATE — DATE
Refund
- WNUM — INT — Primary key — NOT NULL
- CUST_ID — VARCHAR(50) — Foreign key → Costomer.CUST_ID — NOT NULL
- W_CREDIT — INT — NOT NULL
- W_AMOUNT — INT — NOT NULL
Sponsor
- DNUM — INT — Primary key — NOT NULL
- CUST_ID — VARCHAR(50) — Foreign key → Costomer.CUST_ID — NOT NULL
- IDOL_ID — VARCHAR(50) — Foreign key → Idol.IDOL_ID — NOT NULL
- EVENT_ID — VARCHAR(50) — Foreign key → Event.EVENT_ID — NOT NULL
- DTIME — TIME — NOT NULL
- DDATE — DATE — NOT NULL
- D_C — INT — NOT NULL
Unfollow
- FNUM — INT — Primary key — NOT NULL
- CUST_ID — VARCHAR(50) — Foreign key → Costomer.CUST_ID — NOT NULL
- IDOL_ID — VARCHAR(50) — Foreign key → Idol.IDOL_ID — NOT NULL
- FTIME — TIME — NOT NULL
- FDATE — DATE — NOT NULL
Vote
- VNUM — INT — Primary key — NOT NULL
- CUST_ID — VARCHAR(50) — Foreign key → Costomer.CUST_ID — NOT NULL
- IDOL_ID — VARCHAR(50) — Foreign key → Idol.IDOL_ID — NOT NULL
- VTIME — TIME — NOT NULL
- VDATE — DATE — NOT NULL
- V_C — INT — NOT NULL