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