musical

Tables (4)

authorities

  • authority — nvarchar2(50)
  • customer_id (customer_id2) — nvarchar2(50) — Foreign key → customer.customer_id

customer

  • customer_id — nvarchar2(50) — Primary key
  • customer_pw — nvarchar2(255) — NOT NULL
  • customer_phone — nvarchar2(20)
  • customer_email — nvarchar2(255)
  • customer_address — nvarchar2(255)
  • customer_birth — DATE
  • enabled — integer — NOT NULL

persistent_logins

  • username — nvarchar2(50) — NOT NULL
  • series — nvarchar2(64)
  • token — nvarchar2(64) — NOT NULL
  • last_used — timestamp — NOT NULL

qa

  • qa_id — number
  • musical_id — number
  • qa_type — nvarchar2(50)
  • title — nvarchar2(500)
  • content — varchar2(4000)
  • qa_date — date
  • response — varchar2(4000)
  • display — NUMBER(1)
  • customer_id (customer_id2) — nvarchar2(50) — Foreign key → customer.customer_id