hacoDB

Tables (13)

haco_address

  • PK (a_pk) — Primary key — NOT NULL
  • PK (a_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
  • 주소종류 (a_category)
  • 주소값 (a_address)

haco_announcement

  • PK (a_pk) — Primary key — NOT NULL
  • 트위터ID (a_u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
  • 제목 (a_title)
  • 본문 (a_text)
  • 작성일자 (a_date)

haco_archive

  • PK (a_pk) — number (10) primary key — Primary key — NOT NULL
  • 멤버PK (a_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
  • 방송날짜 (a_date) — date not null
  • 방송시각 (a_time) — INTERVAL DAY TO SECOND not null
  • 콜라보여부 (a_collabo) — varchar2 (10 char) not null
  • 콜라보멤버 (a_collabomember)
  • 방송카테고리 (a_category) — varchar2 (50 char) not null
  • 방송제목 (a_title) — varchar2 (200 char) not null
  • 섬네일주소 (a_thumbnail) — varchar2 (100 char) not null

haco_comments

  • PK (c_pk) — number(10) primary key — Primary key — NOT NULL
  • 아카이브PK (c_a_pk) — number (10) — Foreign key → haco_archive.PK — NOT NULL
  • 멤버PK (c_m_pk) — number3 — Foreign key → haco_archive.멤버PK — NOT NULL
  • 트위터ID (u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
  • 타임스탬프 (c_timestamp) — varchar2 (20 char) not null
  • 댓글본문 (c_text) — varchar2 (100 char) not null
  • 작성시간 (c_sysdate) — date not null

haco_goods

  • PK (g_pk) — number (3) primary key — Primary key — NOT NULL
  • 멤버PK (g_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
  • 트위터ID (u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
  • 굿즈종류 (g_category) — varchar2(50 char) not null
  • 굿즈수량 (g_count) — number (2)

haco_hashtag

  • PK (h_pk) — Primary key — NOT NULL
  • PK (h_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
  • 태그종류 (h_category)
  • 태그값 (h_tag)

haco_image

  • PK (i_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
  • 아이콘 (i_icon) — varchar2(300 char)
  • 정면도 (i_pic) — varchar2(300 char)
  • 3면도 (i_3side) — varchar2(300 char)
  • 배경 (i_background) — varchar2(300 char)

haco_member

  • PK (m_pk) — number3 — Primary key — NOT NULL
  • 이름 (m_name) — number3 not null
  • 기수 (m_gen)
  • 생일 (m_birth) — date not null
  • 데뷔일 (m_debut) — date not null
  • 마마이름 (m_mother_name) — varchar2(100 char) not null
  • 마마트위터 (m_mother_twitter) — varchar2(100 char) not null

haco_schedule

  • PK (s_pk) — Primary key — NOT NULL
  • PK (s_m_pk) — number3 — Foreign key → haco_member.PK — NOT NULL
  • 트위터ID (s_u_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
  • 날짜(요일) (s_date)
  • 시간 (s_time)
  • 제목 (s_title)

haco_songstream

  • PK (s_pk) — number(10) primary key — Primary key — NOT NULL
  • 아카이브PK (s_a_pk) — number (10) primary key — Foreign key → haco_archive.PK — NOT NULL
  • 멤버PK (s_m_pk) — number3 — Foreign key → haco_archive.멤버PK — NOT NULL
  • 트위터ID (u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
  • 타임스탬프 (s_timestamp) — varchar2 (20 char) not null
  • 노래이름 (s_songname) — varchar2 (100 char) not null
  • 노래아티스트 (s_artistname) — varchar2 (100 char) not null
  • 작성시간 (s_sysdate) — date not null

haco_tradegoods

  • PK (t_pk) — number(10) — Primary key — NOT NULL
  • 트위터ID (u_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_user.ID
  • 본문 (t_text) — varchar2 (1000char)
  • 작성일자 (t_sysdate) — date not null

haco_tradegoods_comments

  • PK (tc_pk) — Primary key — NOT NULL
  • 본문pk (tc_t_pk) — number(10) — Foreign key → haco_tradegoods.PK — NOT NULL
  • 본문작성자-트위터ID (tc_m_twitter_id) — varchar2 (100 char) not null — Foreign key → haco_tradegoods.트위터ID
  • 댓글작성자-트위터ID (tc_s_twitter_id)
  • 본문 (tc_text)
  • 작성시간 (tc_date)

haco_user

  • ID (u_id) — varchar2 (100 char) not null — Primary key
  • PW (u_pw)
  • 트위터ID (u_twitter_id)
  • 닉네임 (u_nickname) — varchar2 (40 char) not null
  • 활성화여부 (u_yesno)