legacy

Tables (4)

accounts

  • email — VARCHAR(20) — Primary key — NOT NULL
  • email (email2) — varchar(20) — Foreign key → mypage.email — NOT NULL
  • uuid — UUID
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

event

  • email — varchar(20) — Primary key — NOT NULL
  • email (email2) — varchar(20) — Foreign key → mypage.email — NOT NULL
  • 행사이름 (eventname) — varchar(20)
  • 행사시작 (eventstartdate) — date
  • 행사내용 (eventcontent) — varchar(40)
  • 장소 (eventlocation) — varchar(20)
  • 행사이미지 (eventimage) — varchar(500)
  • 행사종료 (eventenddate) — date
  • 문의번호 (eventnumber) — number
  • 참여대상 (eventmenber) — varchar(20)
  • 가격 (eventprice) — int

heritage

  • email — varchar(20) — Primary key — NOT NULL
  • email (email2) — varchar(20) — Foreign key → mypage.email — NOT NULL
  • 장소 (Hlocation) — varchar(20)
  • 시대 (Hage) — varchar(20)
  • 내용 (Hcontent) — varchar(40)
  • 이미지 (Himage) — varchar(500)
  • 이름 (Hname) — varchar(20) — NOT NULL

mypage

  • email — varchar(20) — Primary key — NOT NULL